﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="OrderFollowup" targetNamespace="http://tempuri.org/OrderFollowup.xsd" xmlns:mstns="http://tempuri.org/OrderFollowup.xsd" xmlns="http://tempuri.org/OrderFollowup.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="scfhsConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="scfhsConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.scfhsConnectionString.ConnectionString" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="order_instructionsTableAdapter" GeneratorDataComponentClassName="order_instructionsTableAdapter" Name="order_instructions" UserDataComponentName="order_instructionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="scfhsConnectionString (Web.config)" DbObjectName="scfhs.order_instructions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `order_instructions` WHERE ((`ID` = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `order_instructions` (`AuthorityOf`, `Instruction`, `TransferTo`, `TransferReason`, `SubmitTimestamp`, `FK_OrderID`, `IsFinalInstruction`) VALUES (@AuthorityOf, @Instruction, @TransferTo, @TransferReason, @SubmitTimestamp, @FK_OrderID, @IsFinalInstruction)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AuthorityOf" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AuthorityOf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Instruction" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Instruction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TransferTo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransferTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TransferReason" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransferReason" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@SubmitTimestamp" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="SubmitTimestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FK_OrderID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="FK_OrderID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsFinalInstruction" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IsFinalInstruction" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, AuthorityOf, Instruction, TransferTo, TransferReason, SubmitTimestamp, FK_OrderID, IsFinalInstruction FROM order_instructions</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `order_instructions` SET `AuthorityOf` = @AuthorityOf, `Instruction` = @Instruction, `TransferTo` = @TransferTo, `TransferReason` = @TransferReason, `SubmitTimestamp` = @SubmitTimestamp, `FK_OrderID` = @FK_OrderID, `IsFinalInstruction` = @IsFinalInstruction WHERE ((`ID` = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AuthorityOf" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AuthorityOf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Instruction" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Instruction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TransferTo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransferTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TransferReason" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransferReason" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@SubmitTimestamp" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="SubmitTimestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FK_OrderID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="FK_OrderID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsFinalInstruction" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IsFinalInstruction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="AuthorityOf" DataSetColumn="AuthorityOf" />
              <Mapping SourceColumn="Instruction" DataSetColumn="Instruction" />
              <Mapping SourceColumn="TransferTo" DataSetColumn="TransferTo" />
              <Mapping SourceColumn="TransferReason" DataSetColumn="TransferReason" />
              <Mapping SourceColumn="SubmitTimestamp" DataSetColumn="SubmitTimestamp" />
              <Mapping SourceColumn="FK_OrderID" DataSetColumn="FK_OrderID" />
              <Mapping SourceColumn="IsFinalInstruction" DataSetColumn="IsFinalInstruction" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="OrderFollowup" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="OrderFollowup" msprop:Generator_UserDSName="OrderFollowup">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="order_instructions" msprop:Generator_TableClassName="order_instructionsDataTable" msprop:Generator_TableVarName="tableorder_instructions" msprop:Generator_TablePropName="order_instructions" msprop:Generator_RowDeletingName="order_instructionsRowDeleting" msprop:Generator_UserTableName="order_instructions" msprop:Generator_RowChangingName="order_instructionsRowChanging" msprop:Generator_RowEvHandlerName="order_instructionsRowChangeEventHandler" msprop:Generator_RowDeletedName="order_instructionsRowDeleted" msprop:Generator_RowEvArgName="order_instructionsRowChangeEvent" msprop:Generator_RowChangedName="order_instructionsRowChanged" msprop:Generator_RowClassName="order_instructionsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="AuthorityOf" msprop:Generator_ColumnVarNameInTable="columnAuthorityOf" msprop:Generator_ColumnPropNameInRow="AuthorityOf" msprop:Generator_ColumnPropNameInTable="AuthorityOfColumn" msprop:Generator_UserColumnName="AuthorityOf">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Instruction" msprop:Generator_ColumnVarNameInTable="columnInstruction" msprop:Generator_ColumnPropNameInRow="Instruction" msprop:Generator_ColumnPropNameInTable="InstructionColumn" msprop:Generator_UserColumnName="Instruction" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransferTo" msprop:Generator_ColumnVarNameInTable="columnTransferTo" msprop:Generator_ColumnPropNameInRow="TransferTo" msprop:Generator_ColumnPropNameInTable="TransferToColumn" msprop:Generator_UserColumnName="TransferTo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransferReason" msprop:Generator_ColumnVarNameInTable="columnTransferReason" msprop:Generator_ColumnPropNameInRow="TransferReason" msprop:Generator_ColumnPropNameInTable="TransferReasonColumn" msprop:Generator_UserColumnName="TransferReason" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SubmitTimestamp" msprop:Generator_ColumnVarNameInTable="columnSubmitTimestamp" msprop:Generator_ColumnPropNameInRow="SubmitTimestamp" msprop:Generator_ColumnPropNameInTable="SubmitTimestampColumn" msprop:Generator_UserColumnName="SubmitTimestamp" type="xs:dateTime" />
              <xs:element name="FK_OrderID" msprop:Generator_ColumnVarNameInTable="columnFK_OrderID" msprop:Generator_ColumnPropNameInRow="FK_OrderID" msprop:Generator_ColumnPropNameInTable="FK_OrderIDColumn" msprop:Generator_UserColumnName="FK_OrderID" type="xs:int" />
              <xs:element name="IsFinalInstruction" msprop:Generator_ColumnVarNameInTable="columnIsFinalInstruction" msprop:Generator_ColumnPropNameInRow="IsFinalInstruction" msprop:Generator_ColumnPropNameInTable="IsFinalInstructionColumn" msprop:Generator_UserColumnName="IsFinalInstruction" type="xs:int" />
              <xs:element name="FollowUpSequenceNumber" msprop:Generator_ColumnVarNameInTable="columnFollowUpSequenceNumber" msprop:Generator_ColumnPropNameInRow="FollowUpSequenceNumber" msprop:Generator_ColumnPropNameInTable="FollowUpSequenceNumberColumn" msprop:Generator_UserColumnName="FollowUpSequenceNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FollowUpAuthority" msprop:Generator_ColumnVarNameInTable="columnFollowUpAuthority" msprop:Generator_ColumnPropNameInRow="FollowUpAuthority" msprop:Generator_ColumnPropNameInTable="FollowUpAuthorityColumn" msprop:Generator_UserColumnName="FollowUpAuthority">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FollowUpDate" msprop:Generator_ColumnVarNameInTable="columnFollowUpDate" msprop:Generator_ColumnPropNameInRow="FollowUpDate" msprop:Generator_ColumnPropNameInTable="FollowUpDateColumn" msprop:Generator_UserColumnName="FollowUpDate" type="xs:dateTime" />
              <xs:element name="FollowUpDiscription" msprop:Generator_ColumnVarNameInTable="columnFollowUpDiscription" msprop:Generator_ColumnPropNameInRow="FollowUpDiscription" msprop:Generator_ColumnPropNameInTable="FollowUpDiscriptionColumn" msprop:Generator_UserColumnName="FollowUpDiscription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FollowerName" msprop:Generator_ColumnVarNameInTable="columnFollowerName" msprop:Generator_ColumnPropNameInRow="FollowerName" msprop:Generator_ColumnPropNameInTable="FollowerNameColumn" msprop:Generator_UserColumnName="FollowerName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:order_instructions" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>